145ce9ce65819ee14348bccbc376bb7f3c5e2b99,portal-impl/src/com/liferay/portal/upgrade/v6_1_0/UpgradeJournal.java,UpgradeJournal,doUpgrade,#,31
Before Change
@Override
protected void doUpgrade() throws Exception {
try {
runSQL("alter_column_type JournalArticle title STRING null");
}
catch (Exception e) {
UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
JournalArticleTable.TABLE_NAME,
JournalArticleTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(JournalArticleTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(
JournalArticleTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
}
try {
runSQL("alter_column_type JournalStructure name STRING null");
runSQL(
"alter_column_type JournalStructure description STRING null");
}
catch (Exception e) {
UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
JournalStructureTable.TABLE_NAME,
JournalStructureTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(JournalStructureTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(
JournalStructureTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
}
try {
runSQL("alter_column_type JournalTemplate name STRING null");
runSQL("alter_column_type JournalTemplate description STRING null");
}
catch (Exception e) {
UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
JournalTemplateTable.TABLE_NAME,
JournalTemplateTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(JournalTemplateTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(
JournalTemplateTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
}
updateStructureXsd();
After Change
@Override
protected void doUpgrade() throws Exception {
if (isSupportsAlterColumnType()) {
runSQL("alter_column_type JournalArticle title STRING null");
runSQL("alter_column_type JournalStructure name STRING null");
runSQL(
"alter_column_type JournalStructure description STRING null");
runSQL("alter_column_type JournalTemplate name STRING null");
runSQL("alter_column_type JournalTemplate description STRING null");
}
else {
UpgradeTable upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
JournalArticleTable.TABLE_NAME,
JournalArticleTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(JournalArticleTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(
JournalArticleTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
JournalStructureTable.TABLE_NAME,
JournalStructureTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(JournalStructureTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(
JournalStructureTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
upgradeTable = UpgradeTableFactoryUtil.getUpgradeTable(
JournalTemplateTable.TABLE_NAME,
JournalTemplateTable.TABLE_COLUMNS);
upgradeTable.setCreateSQL(JournalTemplateTable.TABLE_SQL_CREATE);
upgradeTable.setIndexesSQL(
JournalTemplateTable.TABLE_SQL_ADD_INDEXES);
upgradeTable.updateTable();
}
updateStructureXsd();